Unique constraints ensure that the data contained in a column or a group of columns is unique with respect to all the rows in the table.
Uniques are managed on the Uniques tab of the Table Designer. Just simply click an unique field for editing. By using the toolbar below, you can create new, edit and delete the selected unique field.
Add Unique
To add an unique
- Open the table in the Table Designer.
- Open the Uniques tab.
- Click the
Add Unique from the toolbar.
- Edit unique properties.
Edit Unique
To edit an unique
- Open the table in the Table Designer.
- Open the Uniques tab.
- Click on the unique to edit.
Delete Unique
To delete an unique
- Open the table in the Table Designer.
- Open the Uniques tab.
- Click the
Delete Unique from the toolbar.
- Confirm deleting in the dialog window.
See also:
Setting Unique Properties